ExceLint: automatically finding spreadsheet formula errors
نویسندگان
چکیده
منابع مشابه
Finding Errors Automatically in Semantically Tagged Dialogues
We describe a novel method for detecting errors in task-based human-computer (HC) dialogues by automatically deriving them from semantic tags. We examined 27 HC dialogues from the DARPA Communicator air travel domain, comparing user inputs to system responses to look for slot value discrepancies, both automatically and manually. For the automatic method, we labeled the dialogues with semantic t...
متن کاملAvoiding, finding and fixing spreadsheet errors - A survey of automated approaches for spreadsheet QA
Spreadsheet programs can be found everywhere in organizations and they are used for a variety of purposes, including financial calculations, planning, data aggregation and decision making tasks. A number of research surveys have however shown that such programs are particularly prone to errors. Some reasons for the error-proneness of spreadsheets are that spreadsheets are developed by end users...
متن کاملMeasuring Spreadsheet Formula Understandability
Spreadsheets are widely used in industry, because they are flexible and easy to use. Often they are used for business-critical applications. It is however difficult for spreadsheet users to correctly assess the quality of spreadsheets, especially with respect to the understandability. Understandability of spreadsheets is important, since spreadsheets often have a long lifespan, during which the...
متن کاملClassification of Spreadsheet Errors
This paper describes a framework for a systematic classification of spreadsheet errors. This classification or taxonomy of errors is aimed at facilitating analysis and comprehension of the different types of spreadsheet errors. It is far more comprehensive than any presented or published before. The taxonomy is an outcome of a thorough investigation of the widespread problem of spreadsheet erro...
متن کاملReducing Spreadsheet Errors
OVERVIEW: Increasing computational power and memory capacity in desktop computers has resulted in access to numerical techniques previously unavailable to many users. Although computational capabilities have increased, many users are unable to take full advantage of this power due to limited programming expertise. Spreadsheets offer these users a means to capitalize upon computational potential...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Proceedings of the ACM on Programming Languages
سال: 2018
ISSN: 2475-1421
DOI: 10.1145/3276518